﻿CREATE TABLE [dbo].[ts_Broker] (
    [ID]             INT           IDENTITY (1, 1) NOT NULL,
    [Name]           VARCHAR (128) NULL,
    [NickName]       VARCHAR (50)  NULL,
    [Address]        VARCHAR (100) NULL,
    [City]           VARCHAR (50)  NULL,
    [State]          VARCHAR (2)   NULL,
    [Zip]            VARCHAR (5)   NULL,
    [Phone]          VARCHAR (50)  NULL,
    [Fax]            VARCHAR (50)  NULL,
    [ApprovedBroker] BIT           NULL,
    [SalesRep]       VARCHAR (50)  NULL
);

